MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

15 rows where Object Name = 161

View and edit SQL

Suggested facets: Is Public Domain, Department, Title, Artist Role, Artist Nationality, Object Begin Date, Medium, Classification

Link rowid ▼ Object Number Is Highlight Is Public Domain Object ID Department Object Name Title Culture Period Dynasty Reign Portfolio Artist Role Artist Prefix Artist Display Name Artist Display Bio Artist Suffix Artist Alpha Sort Artist Nationality Artist Begin Date Artist End Date Object Date Object Begin Date Object End Date Medium Dimensions Credit Line Geography Type City State County Country Region Subregion Locale Locus Excavation River Classification Rights and Reproduction Link Resource Repository
1036 55.75.3a, b 0 0 1120 American Decorative Arts 1 Centerpiece 161 Centerpiece                             1800–1900 1800 1900 Gilt bronze, glass 307 14 7/8 x 26 1/2 in. (37.8 x 67.3 cm) Gift of Mrs. F. Carrington Weems, 1955                       Metal 1   Metropolitan Museum of Art, New York, NY 1
13633 1993.210 0 1 14795 American Decorative Arts 1 Centerpiece 161 Centerpiece British 6         Maker 1   Benjamin Smith, II active ca. 1790–1830   Smith, Benjamin II 2234 British 7 1787 1830 1821–22 1821 1822 Silver 2 H. 16 in. (40.6 cm); Diam. 11 1/2 in. (29.2 cm) Rogers Fund, 1993 Made in 1 London 14     England 4             Silver 2   Metropolitan Museum of Art, New York, NY 1
99170 83.18.24a–rr 0 1 186506 European Sculpture and Decorative Arts 3 Centerpiece 161 Centerpiece British, after British, London original 2179         Maker 1 After an original by Paul de Lamerie British, 1688–1751, active 1712–51   Lamerie, Paul 8024 British 7 1688 1751 19th century 1800 1899 Silver on base metal 20460 Overall: 10 × 18 × 31 in. (25.4 × 45.7 × 78.7 cm) Gift of Henry G. Marquand, 1883                       Metalwork-Electrotype 136   Metropolitan Museum of Art, New York, NY 1
112493 50.211.61a, b 0 1 200775 European Sculpture and Decorative Arts 3 Centerpiece 161 Centerpiece French, Marseilles 2582                           ca. 1755–60 1750 1765 Faience (tin-glazed earthenware) 20668 Overall: 16 7/8 × 20 1/4 × 14 1/4 in. (42.9 × 51.4 × 36.2 cm) Gift of R. Thornton Wilson, in memory of Florence Ellsworth Wilson, 1950                       Ceramics-Pottery 314   Metropolitan Museum of Art, New York, NY 1
117294 1974.356.673 0 1 206177 European Sculpture and Decorative Arts 3 Centerpiece 161 Table centerpiece German, Augsburg 126         Maker 1   Johann Jakob Adam ca. 1720–1791, master 1748   Adam Johann Jakob 11468   1720 1791 1765–67 1765 1767 Silver 2 Overall: 8 × 12 in. (20.3 × 30.5 cm) The Lesley and Emma Sheafer Collection, Bequest of Emma A. Sheafer, 1973                       Metalwork-Silver 313   Metropolitan Museum of Art, New York, NY 1
117730 1977.216.37 0 1 206655 European Sculpture and Decorative Arts 3 Centerpiece 161 Centerpiece Italian, Venice 122         Factory 328   Cozzi manufactory Italian, 1764–1812   Cozzi manufactory 8322 Italian 6 1764 1812 ca. 1770–80 1765 1785 Hard-paste porcelain 572 11 9/16 × 6 7/8 in. (29.4 × 17.5 cm) Bequest of R. Thornton Wilson, in memory of his wife, Florence Ellsworth Wilson, 1977                       Ceramics-Porcelain 307   Metropolitan Museum of Art, New York, NY 1
117888 1980.202.1 0 1 206827 European Sculpture and Decorative Arts 3 Centerpiece 161 Centerpiece British, Coalport 3013         Manufactory 331   Coalport British, ca. 1799–1926   Coalport 11581 British 7 1794 1926 ca. 1840 1835 1845 Bone porcelain 23436 Diameter: 10 3/4 in. (27.3 cm) Bequest of Florence S. Klopfer, 1980                       Ceramics-Porcelain 307   Metropolitan Museum of Art, New York, NY 1
118313 1982.326.3 0 1 207314 European Sculpture and Decorative Arts 3 Centerpiece 161 Centerpiece British, Staffordshire 2229                           ca. 1815 1810 1820 Pearlware 23566 Height: 14 1/8 in. (35.9 cm) Gift of Mildred R. Mottahedeh, 1982                       Ceramics-Pottery 314   Metropolitan Museum of Art, New York, NY 1
119141 1994.92 0 1 208177 European Sculpture and Decorative Arts 3 Centerpiece 161 Centerpiece British, Stoke-on-Trent, Staffordshire 2292         Factory 328   Minton(s) British, Stoke-on-Trent, 1793–present   Minton 11770 British 7 1793 2001 1866 1866 1866 Porcelain, enameled and gilt 23752 Height: 18 1/2 in. (47 cm) The Charles E. Sampson Memorial Fund, 1994                       Ceramics-Porcelain 307   Metropolitan Museum of Art, New York, NY 1
135772 52.13 0 0 227580 European Sculpture and Decorative Arts 3 Centerpiece 161 Centerpiece Italian or Austrian 3654                           ca. 1900 1895 1905 Linen on linen 24576 Diam. 39 inches (99.1 cm) Gift of Clara S. Peck, 1951                       Textiles-Embroidered 187   Metropolitan Museum of Art, New York, NY 1
137693 1979.81a 0 0 229589 European Sculpture and Decorative Arts 3 Centerpiece 161 Centerpiece Belgian 676                           ca. 1914 1909 1919 Needle lace 24315 Diameter: 30 1/2 in. (77.5 cm) Gift of Mrs. Henry C. Taylor, 1979                       Textiles-Laces 296   Metropolitan Museum of Art, New York, NY 1
337319 1987.462 0 0 484888 Modern and Contemporary Art 4 Centerpiece 161 Centerpiece           Designer|Manufacturer 3   Gio Ponti|Flavio Poli Italian, Milan 1891–1979 Milan|Italian   Ponti, Gio|FLAVIO POLI 45792 Italian|Italian 93 1891 1979 ca. 1950 1950 1950 Enameled metal 8467 H.4-3/8, W.10-3/4, D.3-1/2 inches (11.1 x 27.3 x 8.9 cm.) Gift of Paolo Curti Gallery - Brescia, 1987                       Metalwork-Enamel 890   Metropolitan Museum of Art, New York, NY 1
337455 1988.200a,b 0 0 485027 Modern and Contemporary Art 4 Centerpiece 161 Centerpiece           Designer|Maker|Manufacturer 52   C.B. Blake|Karl Danielson|Tiffany & Co. American|American|1837–present   Blake, C B|Danielson, Karl|Tiffany & Co. 45856 American|American 5 1837 9999 1939 1939 1939 Silver 2 H. 14, W. 7-3/4, D. 7 in. (35.7 x 19.7 x 17.7 cm.) Gift of The Erving and Joyce Wolf Foundation, in memory of Diane R. Wolf, 1988                       Metalwork-Silver 313   Metropolitan Museum of Art, New York, NY 1
338331 1992.207.1 0 0 485947 Modern and Contemporary Art 4 Centerpiece 161 Work 8403           Designer 5   Professor Kyung-hee Hong Korean, born 1954   Hong, Kyung-Hee 46115 Korean 124 1954 2054 1984 1984 1984 Copper and Kuromido 52040 H. 12-1/2, W. 25-1/2, D. 11 in. (31.8 x 64.8 x 27.9 cm.) Gift of Chunghi Choo, 1992                       Metalwork-Copper 324   Metropolitan Museum of Art, New York, NY 1
343223 2000.164.25 0 0 492004 Modern and Contemporary Art 4 Centerpiece 161 Centerpiece           Designer 5   Herman Rosse American (born The Netherlands), The Hague 1887–1965 Nyack, New York   Rosse, Herman 47213 American 1 1887 1965 1928 1928 1928 Monel metal 53087 H. 2 1/4, Diam. 15 in. (5.7 x 38.1 cm) Gift of S. Helena Rosse Trust, 2000                       Metalwork 177   Metropolitan Museum of Art, New York, NY 1

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "MetObjects" (
"Object Number" TEXT,
  "Is Highlight" INTEGER,
  "Is Public Domain" INTEGER,
  "Object ID" INTEGER,
  "Department" INTEGER,
  "Object Name" INTEGER,
  "Title" TEXT,
  "Culture" INTEGER,
  "Period" REAL,
  "Dynasty" INTEGER,
  "Reign" INTEGER,
  "Portfolio" INTEGER,
  "Artist Role" INTEGER,
  "Artist Prefix" REAL,
  "Artist Display Name" TEXT,
  "Artist Display Bio" TEXT,
  "Artist Suffix" REAL,
  "Artist Alpha Sort" INTEGER,
  "Artist Nationality" INTEGER,
  "Artist Begin Date" TEXT,
  "Artist End Date" TEXT,
  "Object Date" TEXT,
  "Object Begin Date" INTEGER,
  "Object End Date" INTEGER,
  "Medium" INTEGER,
  "Dimensions" TEXT,
  "Credit Line" TEXT,
  "Geography Type" INTEGER,
  "City" INTEGER,
  "State" INTEGER,
  "County" INTEGER,
  "Country" INTEGER,
  "Region" INTEGER,
  "Subregion" INTEGER,
  "Locale" INTEGER,
  "Locus" INTEGER,
  "Excavation" INTEGER,
  "River" INTEGER,
  "Classification" INTEGER,
  "Rights and Reproduction" REAL,
  "Link Resource" TEXT,
  "Metadata Date" TEXT,
  "Repository" INTEGER
,
FOREIGN KEY ("Department") REFERENCES [Department](id),
    FOREIGN KEY ("Object Name") REFERENCES [Object Name](id),
    FOREIGN KEY ("Culture") REFERENCES [Culture](id),
    FOREIGN KEY ("Dynasty") REFERENCES [Dynasty](id),
    FOREIGN KEY ("Reign") REFERENCES [Reign](id),
    FOREIGN KEY ("Portfolio") REFERENCES [Portfolio](id),
    FOREIGN KEY ("Artist Role") REFERENCES [Artist Role](id),
    FOREIGN KEY ("Artist Alpha Sort") REFERENCES [Artist Alpha Sort](id),
    FOREIGN KEY ("Artist Nationality") REFERENCES [Artist Nationality](id),
    FOREIGN KEY ("Medium") REFERENCES [Medium](id),
    FOREIGN KEY ("Geography Type") REFERENCES [Geography Type](id),
    FOREIGN KEY ("City") REFERENCES [City](id),
    FOREIGN KEY ("State") REFERENCES [State](id),
    FOREIGN KEY ("County") REFERENCES [County](id),
    FOREIGN KEY ("Country") REFERENCES [Country](id),
    FOREIGN KEY ("Region") REFERENCES [Region](id),
    FOREIGN KEY ("Subregion") REFERENCES [Subregion](id),
    FOREIGN KEY ("Locale") REFERENCES [Locale](id),
    FOREIGN KEY ("Locus") REFERENCES [Locus](id),
    FOREIGN KEY ("Excavation") REFERENCES [Excavation](id),
    FOREIGN KEY ("River") REFERENCES [River](id),
    FOREIGN KEY ("Classification") REFERENCES [Classification](id),
    FOREIGN KEY ("Repository") REFERENCES [Repository](id));
CREATE INDEX ["MetObjects_Department"] ON [MetObjects]("Department");
CREATE INDEX ["MetObjects_Object Name"] ON [MetObjects]("Object Name");
CREATE INDEX ["MetObjects_Culture"] ON [MetObjects]("Culture");
CREATE INDEX ["MetObjects_Dynasty"] ON [MetObjects]("Dynasty");
CREATE INDEX ["MetObjects_Reign"] ON [MetObjects]("Reign");
CREATE INDEX ["MetObjects_Portfolio"] ON [MetObjects]("Portfolio");
CREATE INDEX ["MetObjects_Artist Role"] ON [MetObjects]("Artist Role");
CREATE INDEX ["MetObjects_Artist Alpha Sort"] ON [MetObjects]("Artist Alpha Sort");
CREATE INDEX ["MetObjects_Artist Nationality"] ON [MetObjects]("Artist Nationality");
CREATE INDEX ["MetObjects_Medium"] ON [MetObjects]("Medium");
CREATE INDEX ["MetObjects_Geography Type"] ON [MetObjects]("Geography Type");
CREATE INDEX ["MetObjects_City"] ON [MetObjects]("City");
CREATE INDEX ["MetObjects_State"] ON [MetObjects]("State");
CREATE INDEX ["MetObjects_County"] ON [MetObjects]("County");
CREATE INDEX ["MetObjects_Country"] ON [MetObjects]("Country");
CREATE INDEX ["MetObjects_Region"] ON [MetObjects]("Region");
CREATE INDEX ["MetObjects_Subregion"] ON [MetObjects]("Subregion");
CREATE INDEX ["MetObjects_Locale"] ON [MetObjects]("Locale");
CREATE INDEX ["MetObjects_Locus"] ON [MetObjects]("Locus");
CREATE INDEX ["MetObjects_Excavation"] ON [MetObjects]("Excavation");
CREATE INDEX ["MetObjects_River"] ON [MetObjects]("River");
CREATE INDEX ["MetObjects_Classification"] ON [MetObjects]("Classification");
CREATE INDEX ["MetObjects_Repository"] ON [MetObjects]("Repository");
CREATE INDEX metobjects_IsHighlight ON MetObjects("Is Highlight");
CREATE INDEX metobjects_IsPublicDomain ON MetObjects("Is Public Domain");
CREATE INDEX metobjects_Department ON MetObjects("Department");
CREATE INDEX metobjects_Culture ON MetObjects("Culture");
CREATE INDEX metobjects_Period ON MetObjects("Period");
CREATE INDEX metobjects_Dynasty ON MetObjects("Dynasty");
CREATE INDEX metobjects_Medium ON MetObjects("Medium");
CREATE INDEX metobjects_City ON MetObjects("City");
CREATE INDEX metobjects_State ON MetObjects("State");
CREATE INDEX metobjects_County ON MetObjects("County");
CREATE INDEX metobjects_Country ON MetObjects("Country");
CREATE INDEX metobjects_Region ON MetObjects("Region");
CREATE INDEX metobjects_Subregion ON MetObjects("Subregion");
CREATE INDEX metobjects_Locale ON MetObjects("Locale");
CREATE INDEX metobjects_Locus ON MetObjects("Locus");
CREATE INDEX metobjects_Excavation ON MetObjects("Excavation");
CREATE INDEX metobjects_River ON MetObjects("River");
Powered by Datasette · Query took 551.198ms · Data license: CC0 · Data source: metmuseum/openaccess